﻿    /***************************************************************************************************
    **  Table:	    public.project
    **  Author:		Zhixian Ong
    **
    **  Description:
    **    
    **    Represents a registered project.
    **
    **  Modification History:
    **
    **      20140102  Zhixian Ong     - Initial data
    ** 
    **  Status:
    **      Dev
    ** 
    ***************************************************************************************************/

	----------------------------------------------------------------------------
	-- Insert

    INSERT INTO public.project (name, alias) VALUES ('Skyline',     'Skyline');
    INSERT INTO public.project (name, alias) VALUES ('Horizons',    'Horizons');
    INSERT INTO public.project (name, alias) VALUES ('Otect',       'Otect');

    INSERT INTO public.project (name, alias) VALUES ('Group Finance Portal',                        'GF-Portal');
    INSERT INTO public.project (name, alias) VALUES ('Corporate Pass',                              'Corporate Pass');
    INSERT INTO public.project (name, alias) VALUES ('Policy Acknowledgement System',               'PAS');
    INSERT INTO public.project (name, alias) VALUES ('Staff Movements Applet',                      'Staff Movements Applet');
    INSERT INTO public.project (name, alias) VALUES ('Employee Directory App',                      'Employee Directory App');
    INSERT INTO public.project (name, alias) VALUES ('Hand Phone Directory App',                    'Hand Phone Directory App');
    INSERT INTO public.project (name, alias) VALUES ('Employee Directory and B2E Profile Sync App', 'Employee Directory and B2E Profile Sync App');
    INSERT INTO public.project (name, alias) VALUES ('SharePoint List Consolidator App',            'SharePoint List Consolidator App');
    INSERT INTO public.project (name, alias) VALUES ('K2Portal SiteMap App',                        'K2Portal SiteMap App');
    INSERT INTO public.project (name, alias) VALUES ('K2Portal Counters',                           'K2Portal Counters');
    INSERT INTO public.project (name, alias) VALUES ('K2Portal JavaScript Menu',                    'K2Portal JavaScript Menu');
    INSERT INTO public.project (name, alias) VALUES ('Prime News App and Applet',                   'Prime News App and Applet');
    INSERT INTO public.project (name, alias) VALUES ('Staff Recruitment Managerment',               'SRM');
    INSERT INTO public.project (name, alias) VALUES ('Centralised Defect Management System',        'CDMS');
    INSERT INTO public.project (name, alias) VALUES ('Staff Movements',                             'Staff Movements');
    INSERT INTO public.project (name, alias) VALUES ('eBizCard',                                    'eBizCard');
    INSERT INTO public.project (name, alias) VALUES ('Announcements',                               'Announcements');
    INSERT INTO public.project (name, alias) VALUES ('Safety Issue List',                           'Safety Issue List');
    INSERT INTO public.project (name, alias) VALUES ('Departmental Sites',                          'Departmental Sites');



	----------------------------------------------------------------------------
	-- Select

    SELECT * FROM public.project;
    